<?php
include_once "lib/config.php";
include_once "header.php";

if(isset($_SESSION['msg_success']) && $_SESSION['msg_success']!="")
{
	$msg_success=$_SESSION['msg_success'];
	unset($_SESSION['msg_success']);
}

if(isset($_SESSION['msg_error']) && $_SESSION['msg_error']!="")
{
	$msg_error=$_SESSION['msg_error'];
	unset($_SESSION['msg_error']);
}

if(isset($_POST['user_id']) && $_POST['user_id']>0 && isset($_POST['opt_status']) && $_POST['opt_status']!="")
{
	if($_POST['opt_status']=="Deleted")
    {
        //DB::deleteData("af_users",array("id"=>$_POST['user_id']));
        //$msg_success="Allyfolio User Deleted successfully.";
    }
    else
    {
    	$arr_sanitize=array(":userid"=>$_POST['user_id']);
        
        if($_POST['opt_status']==1)
    	{
    	    DB::query(" update af_users set Activation_Status='Active' where User_ID in (:userid) ",$arr_sanitize);
    		$msg_success="Allyfolio User acctount/s Activated successfully.";
    	}
    	if($_POST['opt_status']==0)
    	{
    	    DB::query(" update af_users set Activation_Status='Blocked' where User_ID in (:userid) ",$arr_sanitize);
    		$msg_success="Allyfolio User account/s Blocked successfully.";
    	}
     }
}

if(!isset($_POST['order_by']))
{
	$_POST['order_by']="asc";
}

if(!isset($_POST['type_title']))
{
	$_POST['type_title']="Full_Name";
}

if(!isset($_POST['pid']))	// code starts for implementing pagination 
{
	$_POST['pid']=1;
}

$selectquery="select User_ID,Email_ID,DOB,Gender,Mobile_Number,Full_Name,Activation_Status from af_users where User_ID>0 ";
$conditionarr=array();

if(isset($_POST['searchText']) && $_POST['searchText']!="" && isset($_POST['filterby']) && $_POST['filterby']!="")
{
    $selectquery.=" and ".$_POST['filterby']." like :".$_POST['filterby'];
	$conditionarr[":".$_POST['filterby']]= "%".$_POST['searchText']."%";
}

$totalrecords=DB::fetch_num_of_rows(DB::query($selectquery,$conditionarr));

$selectquery.=" order by ".$_POST['type_title']." ".$_POST['order_by']." limit ".(($_POST['pid']-1)*PAGELIMIT).", ".PAGELIMIT;

$usersinfo=DB::fetch_array(DB::query($selectquery,$conditionarr));

include_once "lib/paginate_class.php";

$paging_obj=new Paginate();

$pagingdiv=$paging_obj->getnewpager($_POST['pid'],$totalrecords);


?>
        
		<div class="container_12">
        
            <div class="bottom-spacing">
                	
                    <!-- Button -->
                    <br>
                    <form name="mainform" method="post">
	                    <!-- Table records filtering -->
	                    Filter By: 
	                    <select class="input-short" style="width:200px;" name="filterby" id="filterby">
	                    	<option value="" selected="selected">Select filter</option>
	                        <option value="Full_Name"  <?php if(isset($_POST['filterby']) && $_POST['filterby']=="Full_Name"){ echo "selected"; } ?> >Allyfolio User Name</option>
                            <option value="Email_ID"  <?php if(isset($_POST['filterby']) && $_POST['filterby']=="Email_ID"){ echo "selected"; } ?> >Email Id</option>
	                        <option value="Mobile_Number"  <?php if(isset($_POST['filterby']) && $_POST['filterby']=="Mobile_Number"){ echo "selected"; } ?> >Contact Number</option>
	                    </select>
	                    &nbsp;&nbsp;&nbsp;&nbsp;
	                    <input type="text" class="input-short" style="width:300px;" name="searchText" id="searchText" value="<?php if(isset($_POST['searchText'])){ echo $_POST['searchText']; } ?>">
	                    &nbsp;&nbsp;
	                    <input type="button" class="submit-green" value="Search" onclick="return getempfilterresults();"> &nbsp;&nbsp;<input type="button" class="submit-green" value="Show All" onclick="window.location.href='users.php';">
	                    <input type="hidden" name="user_id" id="user_id">
	                    <input type="hidden" name="opt_status" id="opt_status">
						<input type="hidden" name="pid" id="pid" value="<?php if(isset($_POST['pid']))echo $_POST['pid']; ?>">
						<input type="hidden" name="type_title" id="type_title" value="<?php if(isset($_POST['type_title']))echo $_POST['type_title']; ?>">
						<input type="hidden" name="order_by" id="order_by" value="<?php if(isset($_POST['order_by']))echo $_POST['order_by']; ?>">
						
					</form>
                	<br>
            </div>
            
            
                <!-- Example table -->
                <div class="module" style="width:100% !important;">
                	<h2><span>Allyfolio Users List</span></h2>
                    
                    <div class="module-table-body">
                    	
                        <table id="myTable" >
                        	<thead>
                                <tr>
                                    <!--<th style="width:10%"><input type="checkbox" id="checkall" onclick="return checkuncheckall(<?php //echo count($usersinfo); ?>);" /></th>-->
                                    <th style="width:10%">Sr.No.</th>
                                    <th style="width:15%"><a href="javascript:void(0)" onclick="return change_order('Full_Name','<?php echo $_POST['order_by'] ?>')" >Name</a></th>
                                    <th style="width:25%"><a href="javascript:void(0)" onclick="return change_order('Email_ID','<?php echo $_POST['order_by'] ?>')" >Email ID</a></th>
                                    <th style="width:10%"><a href="javascript:void(0)" onclick="return change_order('Mobile_Number','<?php echo $_POST['order_by'] ?>')" >Contact Number</a></th>
                                    <th style="width:10%"><a href="javascript:void(0)" onclick="return change_order('DOB','<?php echo $_POST['order_by'] ?>')" >Date Of Birth</a></th>
                                    <th style="width:10%"><a href="javascript:void(0)" onclick="return change_order('Gender','<?php echo $_POST['order_by'] ?>')" >Gender</a></th>
                                    <th style="width:12%"><a href="javascript:void(0)" onclick="return change_order('Activation_Status','<?php echo $_POST['order_by'] ?>')" >Status</a></th>
                                    <th style="width:18%">Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                            <?php
                            if(count($usersinfo)>0)
                            {
                            	$count=0;
                            	for($i=0;$i<count($usersinfo);$i++)
                            	{
                            		$count++;
                            ?>
							    <tr <?php if($count%2==0)echo "class='odd'"; else echo "class='even'"; ?>>
                                    <!--<td><input type="checkbox" id="check<?php //echo $i; ?>" value="<?php //echo $usersinfo[$i]['User_ID']; ?>" /></td>-->
                                    <td class="align-center"><?php echo ($i+1);  ?></td>
                                    <td><!--<a href="javascript:void(0);" onclick="return editrecord(<?php //echo $usersinfo[$i]['User_ID']; ?>,'user_id','view_user.php');">--><?php echo $usersinfo[$i]['Full_Name']; ?><!--</a>--></td>
                                    <td><?php echo trim($usersinfo[$i]['Email_ID']); ?></td>
                                    <td><?php if(trim($usersinfo[$i]['Mobile_Number'])==0){ echo "NA"; }else{ echo trim($usersinfo[$i]['Mobile_Number']); } ?></td>
                                    <td><?php echo date("d/m/Y",$usersinfo[$i]['DOB']); ?></td>
                                    <td><?php echo trim($usersinfo[$i]['Gender']); ?></td>
                                    <td><?php echo $usersinfo[$i]['Activation_Status'];  ?></td>
                                    <td>
                                    	<?php if($usersinfo[$i]['Activation_Status']=="Pneding" || $usersinfo[$i]['Activation_Status']=="Blocked"){  ?><a href="javascript:void(0);" onclick="return performoperation('activate the user account',1,<?php echo $usersinfo[$i]['User_ID']; ?>,'user_id');"><img src="images/tick-circle.gif" width="16" height="16" title="Activate" /></a><?php }else{ ?>
                                    	<a href="javascript:void(0);" onclick="return performoperation(' block user account ',0,<?php echo $usersinfo[$i]['User_ID']; ?>,'user_id');"><img src="images/minus-circle.gif" width="16" height="16" title="Inactivate" /></a><?php } ?>
                                        <!--<a href="javascript:void(0);" onclick="return editrecord(<?php //echo $usersinfo[$i]['id']; ?>,'user_id','view_user.php');"><img src="images/pencil.gif" width="16" height="16" title="Edit" /></a>-->
                                    </td>
                                </tr>
                            <?php
                            	}
                            }
                            else
                            {
								?>
								<tr>
									<td colspan="8"><span class="redspan">There is no record found!!!</span></td>
								</tr>
								<?php	
							}
                            ?>
                            </tbody>
                        </table>
                        <br>
                        <?php echo $pagingdiv; ?>
                        
                        <div style="clear: both"></div>
                     </div> <!-- End .module-table-body -->
                </div> <!-- End .module -->
                
                
            
            <div style="clear:both;"></div>
            
            
        </div> <!-- End .container_12 -->
		
<?php include_once("footer.php"); ?>   
<?php
if(isset($msg_success) && $msg_success!="")
{
	$notymessage=$msg_success;
	$msgtype="success";
}
else if(isset($msg_error) && $msg_error!="")
{
	$msgtype="error";
	$notymessage=$msg_error;
}
else
{
	$msgtype="";
}
if($msgtype!="")
{
?>        
<script language="javascript">
//<![CDATA[
	$(document).ready(function(){
		
		var options = $.parseJSON('{"text":"<?php echo $notymessage; ?>","layout":"top","type":"<?php echo $msgtype; ?>"}');
		noty(options);
		
	});
//]]>
</script>  
<?php
}
?>   
<script lang="javascript">
//<![CDATA[
function checkuncheckall(totalcount)
{
    var checkflag=true;
    if(!document.getElementById('checkall').checked)
    {
        checkflag=false;
    }
    for(i=0;i<totalcount;i++)
    {
        document.getElementById('check'+i).checked=checkflag;
    }
}
//]]>
</script>  